create procedure [dbo].[BAEGetSuperProductAttributeValueForProductViewFromCartView] @pCode varchar(24),
     @pID int,
     @attributeID int as
SELECT     DISTINCT OrderSuperProductAttributeValue.OrderSuperProductAttributeValueID
FROM    OrderSuperProductChildProduct INNER JOIN
    OrderSuperProductChildProductAttribute ON
    OrderSuperProductChildProduct.OrderSuperProductChildProductID = OrderSuperProductChildProductAttribute.OrderSuperProductChildProductID INNER JOIN
    OrderSuperProductAttributeValue ON
    OrderSuperProductChildProductAttribute.OrderSuperProductAttributeValueID = OrderSuperProductAttributeValue.OrderSuperProductAttributeValueID INNER JOIN
    OrderSuperProductAttributeLookup ON OrderSuperProductChildProduct.OrderProductID = OrderSuperProductAttributeLookup.OrderProductID
WHERE    (OrderSuperProductChildProduct.OrderProductID = @pID) AND (OrderSuperProductAttributeValue.OrderSuperProductAttributeID = @attributeID) AND
    (OrderSuperProductChildProduct.ProductCode = @pCode)

GO